UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8PXUS7ALT7mXl/RKZcN14AdXBEHT5o7NP/ubLi+MbAA='
WHERE
key_id = 'e16a4a18e8b6ca908b0a1b7ed1547bdcbee611339a35415e7049c17ca33ff0e5'
AND (
token = '8PXUS7ALT7mXl/RKZcN14AdXBEHT5o7NP/ubLi+MbAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)