UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NWnxUcHsiUfOmyTmSWbE+LPGUNg0+XdjgzEXMzksriU='
WHERE
key_id = 'd96c6e780e3b6148ea581cbcab3100d3945543fd32b7513a78910e60473daab2'
AND (
token = 'NWnxUcHsiUfOmyTmSWbE+LPGUNg0+XdjgzEXMzksriU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)