UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v85mv9k01LSt8BloW4lNJ7mPNjAF3hqnUcj/fAGjrrs='
WHERE
key_id = 'b1c177e4e000148112c9e963822b5cde8f810a3c0b98eeeb19050c2edfa072e0'
AND (
token = 'v85mv9k01LSt8BloW4lNJ7mPNjAF3hqnUcj/fAGjrrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)