UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42rv1+AKsTx/tf2pC7i7LGhxwhtkFiTH3rsqnevAIgY='
WHERE
key_id = '28810123062f14971a57ed1e39bc9f5d314a0b742602aa3814974c57ed0004e8'
AND (
token = '42rv1+AKsTx/tf2pC7i7LGhxwhtkFiTH3rsqnevAIgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)