UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLxOYWNuv7xrV5oAoGUsz5OjgonRwJ8lym5VC334gfQ='
WHERE
key_id = '62b08a4ad5580e14651f13edd76f85a389cd5a50a7ec26a22c42fbe10ea8857a'
AND (
token = 'JLxOYWNuv7xrV5oAoGUsz5OjgonRwJ8lym5VC334gfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)