UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9+FutJNqmUWhOfa6j8MLjTM6fVTQCKMORvGY7Wm8s0='
WHERE
key_id = '6908e257d9aec1bbac00466deef38197c9f261668de362e17f0054f4b8a174a6'
AND (
token = 'J9+FutJNqmUWhOfa6j8MLjTM6fVTQCKMORvGY7Wm8s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)