UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XrgiTkHNS4USdv/o4veWO/p8/p5ZkifqIui6WQChVM='
WHERE
key_id = '02d7342d0f253687f394ba94ce3bf77bd1e15525b57760a62dab19c83261fcf7'
AND (
token = '5XrgiTkHNS4USdv/o4veWO/p8/p5ZkifqIui6WQChVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)