UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2178QSy7laY2peQ2Rup0f+TPYsfBkNZIS1AuJSf1udc='
WHERE
key_id = 'd96c8e5c128f698465516f0b36323c6398a72e5f1379dc3e92a50312e6e04228'
AND (
token = '2178QSy7laY2peQ2Rup0f+TPYsfBkNZIS1AuJSf1udc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)