UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNdshNdWOTJ9PHoD+oulxY/eib9iSqNfoDaAAgzF6G8='
WHERE
key_id = '65146d9a25a4cd4c659c4aa96ca310867113a1629f7c87d51b6d2f936078b845'
AND (
token = 'qNdshNdWOTJ9PHoD+oulxY/eib9iSqNfoDaAAgzF6G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)