UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qE2O1EtYqa3IgVb7PhxU8utcBB6d7C6p4coB2NVNNn0=' 
WHERE 
  key_id = '6a75166e31970b0f882c859ddfaa117876411c2d8c8f7131d26261cafccc9ad8' 
  AND (
    token = 'qE2O1EtYqa3IgVb7PhxU8utcBB6d7C6p4coB2NVNNn0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024