UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ4tXKvoWDnZMrZ5RJlTsxnXIvRt4GKL51IIvnM6MPk='
WHERE
key_id = 'd7be95fd305215236c0a339e38ad9752b9406a71a531e5c645a026220843bd01'
AND (
token = 'xQ4tXKvoWDnZMrZ5RJlTsxnXIvRt4GKL51IIvnM6MPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)