UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uHkdLuNfyY2GpmQNM6zOmTgLL+fGBxQcbeanqEyGANo='
WHERE
key_id = '1bc59eb4f4992bbe7047fc9fe959bf98f78b96d41d949ba5789e3b27a91b8d36'
AND (
token = 'uHkdLuNfyY2GpmQNM6zOmTgLL+fGBxQcbeanqEyGANo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)