UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vc9tppx6D7z04CLc4Kan/521xLOzf23n5Zq45f44Usc='
WHERE
key_id = 'b1ac01212d532bd5744e665f1f9d6ff484d6bbb8dc34a37da80bb797e0935c5c'
AND (
token = 'vc9tppx6D7z04CLc4Kan/521xLOzf23n5Zq45f44Usc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)