UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KffprzCBdqLxLNp5aqEHO/xLTNxH1Rkfn+8QdKm+ero='
WHERE
key_id = '9c95ab596682871aace85e0bc9d9943375cbff85e53ec674ab2d9f119b7e8c95'
AND (
token = 'KffprzCBdqLxLNp5aqEHO/xLTNxH1Rkfn+8QdKm+ero='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)