UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zDQhr5ig8x5b8MZe3ISQgkADqAWiWhKMSdL4BI2tDY='
WHERE
key_id = 'cf09fa449f4053a98d261dae11fcf4df35d4cff1151f6ccf13e43755f5b6ee16'
AND (
token = '8zDQhr5ig8x5b8MZe3ISQgkADqAWiWhKMSdL4BI2tDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)