UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSc92B3uheEQjMrfPXlq3oWP4WqqRY0XV9eJFqhj0HE='
WHERE
key_id = '9e1a8fd4b55597bd469db14da723aef3efe41eb69cdce95c2f13b2799ec7c480'
AND (
token = 'oSc92B3uheEQjMrfPXlq3oWP4WqqRY0XV9eJFqhj0HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)