UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VN4lH2r/+Oi7fQsD8S9uel4AAUUtCEohGFa6jL/9a9M='
WHERE
key_id = 'c4a1dc9838e36d242eaac0b7ab7aaa2a1da3431ce671837b1613c24cdf527d79'
AND (
token = 'VN4lH2r/+Oi7fQsD8S9uel4AAUUtCEohGFa6jL/9a9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)