UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hc6ZJ5dvjX8TezgX1I1yBM8sffjSvFxSKxweoYIL0Hs='
WHERE
key_id = '7c444d6a2e20918815f0fb66a46dc396ce398082db72db834c0002d8c813d248'
AND (
token = 'Hc6ZJ5dvjX8TezgX1I1yBM8sffjSvFxSKxweoYIL0Hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)