UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzHeN3gWrryfrgWdFKRN2GTeMAg3o/JFAGAaGIf0OGs='
WHERE
key_id = '6afcaf830afa7fc9f8a626d9e9e57800a011a83a249c577a299143182cff2706'
AND (
token = 'pzHeN3gWrryfrgWdFKRN2GTeMAg3o/JFAGAaGIf0OGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)