UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XX7eoVedfrw0EIhc/Pt846CXGlMX5Ca4ofS0HCIi56M='
WHERE
key_id = '9d19fb0713bc80df3203a90c3d1b0b8289697df4daed0ecc0ac58b1fe3fdf27b'
AND (
token = 'XX7eoVedfrw0EIhc/Pt846CXGlMX5Ca4ofS0HCIi56M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)