UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlyfWt9t8ZSyZFdHGPV8w6XuSyNCnvIPXXqEMUmElwI='
WHERE
key_id = '9527dd5e6c8880d615ce6f5a01294373172e57305cd959e8276cd1c66c2e0c48'
AND (
token = 'ZlyfWt9t8ZSyZFdHGPV8w6XuSyNCnvIPXXqEMUmElwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)