UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afSyucaDlD2/lt+8wM1zvMyad63ss7uo7qCx2bfX+sw='
WHERE
key_id = 'b42b2ffd573cf8a269c70b7b966c4a1a2638a8c34fcb79b6e21b3dba7576a79b'
AND (
token = 'afSyucaDlD2/lt+8wM1zvMyad63ss7uo7qCx2bfX+sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)