UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WmVVK+VP4Y9zJkcX3ZrqavfE7xjIC8BKAzsK4z9KQpw='
WHERE
key_id = '3b865a5b200d72c429aed68e618b000a53cb085d7a16d02b3bf1a1ec267f9739'
AND (
token = 'WmVVK+VP4Y9zJkcX3ZrqavfE7xjIC8BKAzsK4z9KQpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)