UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cmc63AwRz4d5a4L4hhJqziDn0/wZsZLW7nc/aOSPHSw='
WHERE
key_id = 'aea1598edbc5779aec20f90a420f7aa93521b15af90324e317ca37ea47a990bc'
AND (
token = 'Cmc63AwRz4d5a4L4hhJqziDn0/wZsZLW7nc/aOSPHSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)