UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GxWHCrwlyG/sIZXMRR/XGxadeAxd/LuZvRnBpA3CSEc='
WHERE
key_id = 'c2d1bc008dbc48a14212e4474cac9f61bd6c88baf4261de8080a182819a1975a'
AND (
token = 'GxWHCrwlyG/sIZXMRR/XGxadeAxd/LuZvRnBpA3CSEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)