UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hCU+wbhVOx80aOqEAvuPY2ofivTaP0dKRZnoG7G7aw='
WHERE
key_id = '0a41e1f164227fd5c7bf444c03082aef1746e337a4ebe2dff46f609ec9432e93'
AND (
token = '6hCU+wbhVOx80aOqEAvuPY2ofivTaP0dKRZnoG7G7aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)