UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UVhOtajrv3EVjBHpFLgVRdPaDPjFFJhq95PRKsrrLo='
WHERE
key_id = 'e7f5bd0b72e721aa4d895a161722e3f664660c9224818026f9c783a262aedc7f'
AND (
token = '7UVhOtajrv3EVjBHpFLgVRdPaDPjFFJhq95PRKsrrLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)