UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5tCj2lEG6pH3dvpBxGh21eDyKo7vCaxhcl/RyCVtwko='
WHERE
key_id = 'ccaa0a0c9e05059ddaf5bb5f9d1d50739c016ee91111e9c0e2d1792be2a3bb64'
AND (
token = '5tCj2lEG6pH3dvpBxGh21eDyKo7vCaxhcl/RyCVtwko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)