UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6JfZ+WaovVzBS4HjM5GrXtny3Al9plOgnE40aZxxS0='
WHERE
key_id = 'd6c34c91f53da2cf24329ca92090b8b24eadfc386573307dbd789b080d1b05f1'
AND (
token = 'q6JfZ+WaovVzBS4HjM5GrXtny3Al9plOgnE40aZxxS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)