UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2xWcM+IyDNXTZwxb9KGev/Kvb1MZlRdGjPFSN1SG88='
WHERE
key_id = '28f91c8401925433dc001333c44b882cc1efe2c22f700ba2c0fd449d2a141835'
AND (
token = 'd2xWcM+IyDNXTZwxb9KGev/Kvb1MZlRdGjPFSN1SG88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)