UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCrH6BnTImEWMP0oitLX0XJLbBlqqswqIv3019/RnBA='
WHERE
key_id = '181d7aca7016ecd0830f43aa7c033ed9e6d2a9477bc0ee1d7c129806b5535550'
AND (
token = 'HCrH6BnTImEWMP0oitLX0XJLbBlqqswqIv3019/RnBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)