UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NoFeq+5UMyL6ZTeDCid4j1lb1b7/N0KBBuNs0+VWEc='
WHERE
key_id = 'd5c48f149f62361dfcd262096c58f71a7c8da279c093f38090cb743c05cb8f8a'
AND (
token = '6NoFeq+5UMyL6ZTeDCid4j1lb1b7/N0KBBuNs0+VWEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)