UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0zvlWkn/pIkzBGvXHn6xkcvFFnZKYU66S5ShD2wjHQ='
WHERE
key_id = '6a47c55178d973b6393d04ce2b2a02d515010d3ebe067837310844d446fc1128'
AND (
token = 'f0zvlWkn/pIkzBGvXHn6xkcvFFnZKYU66S5ShD2wjHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)