UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bA8SnsMD7Clykae+BChK70attFs/2jLayzHJCR+yAdA='
WHERE
key_id = '9f7cba3f71530d7f14bbcbcb9e661451ff0cd555191f2420f9caf053f4e3aac4'
AND (
token = 'bA8SnsMD7Clykae+BChK70attFs/2jLayzHJCR+yAdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)