UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzcaCMRHxZnlqqJDDd3wXBMfVrGdG3M6G8jz/IXj+CA='
WHERE
key_id = 'd65f6b4955badd3087fed2bfd2d0e6a99c8748fdf0256f0aa07e8a4127901220'
AND (
token = 'XzcaCMRHxZnlqqJDDd3wXBMfVrGdG3M6G8jz/IXj+CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)