UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wfz4xMtb/cbixgcLXXk2kOYEHE9kqz8VXQjyC4ghLnA='
WHERE
key_id = 'd71ff11b98cae8f974c0e38cd1ec826bc139e41d5051c9a643a2161452b77405'
AND (
token = 'Wfz4xMtb/cbixgcLXXk2kOYEHE9kqz8VXQjyC4ghLnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)