UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7+D6XxWhnNAVU5fRTt2dRq4SFzqYKaFGFE54l592ZA='
WHERE
key_id = '0996144c30cff3ae0405867a2d1b77d8a807096b56c9a79469838d5b4772ebb5'
AND (
token = 'i7+D6XxWhnNAVU5fRTt2dRq4SFzqYKaFGFE54l592ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)