UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIv/4r6d2QtJL0WHCnhfMxrIFh777914kYHrMn9gkcE='
WHERE
key_id = '096f5a4001b03e800d7bc2dd28c79a870f592bd19cc53001e992dce9d891403e'
AND (
token = 'ZIv/4r6d2QtJL0WHCnhfMxrIFh777914kYHrMn9gkcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)