UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFhQw82xNAJmwWssGJzfwCmaxIwTN5AfyWnUKjR+b3s='
WHERE
key_id = '8507543bd793e5f9921223a77395bb4b53006afa33e90ce9bf3c5226556bd3ec'
AND (
token = 'TFhQw82xNAJmwWssGJzfwCmaxIwTN5AfyWnUKjR+b3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)