UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgEe/q5IpDmJuyGOVCwdkU09G7sIIL4DgBR3apLjpHk='
WHERE
key_id = 'a22e7375f722125ca5a0ebf3e03c762fb271a6c64371896ab961d56fa7b9ef3b'
AND (
token = 'CgEe/q5IpDmJuyGOVCwdkU09G7sIIL4DgBR3apLjpHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)